-- --------------------------------------------------------

--
-- Table structure for table `HW5_BREED`
--



CREATE TABLE IF NOT EXISTS `HW5_BREED` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `SpeciesIDfk` int(10) NOT NULL,
  `Breed` varchar(70) NOT NULL,
  PRIMARY KEY (`ID`)
) 
ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=64 ;



--
-- Dumping data for table `HW5_BREED`
--



INSERT INTO `HW5_BREED` (`ID`, `SpeciesIDfk`, `Breed`) VALUES

(1, 1, 'Norwegian Long-Haired '),
(2, 2, 'Beagle'),
(3, 3, 'Its a yellow fish'),

(4, 2, 'Mix'),
(5, 2, 'Pug'),
(6, 2, 'Terrier'),
(7, 2, 'Miniature Yorkie'),

(8, 1, 'Orange Tabby'),
(9, 2, 'Beagle/Lab'),
(10, 1, 'Persian'),
(11, 2, 'Bishon Frise'),

(12, 2, 'Labrador Retriever'),
(13, 2, 'Shnoodle'),
(14, 2, 'Lab mix'),

(15, 2, 'English Labrador Retriever'),
(16, 2, 'Black Lab / Great Dane'),

(17, 2, 'Labrador'),
(18, 2, 'German Shepard'),
(19, 3, 'African Cichild'),

(20, 2, 'Calvalier King Charles Spaniel'),
(21, 4, 'French Lop'),
(22, 2, 'Border Collie'),

(23, 2, 'McNabb'),
(24, 2, 'Red Blood Hound'),
(25, 1, 'American Short Hair'),

(26, 2, 'American Staffordshire Terrier Mix'),
(27, 2, 'Siberian Husky'),

(28, 2, 'Doberman Pincher'),
(29, 2, 'Chihuahua'),
(30, 1, 'Tuxedo'),

(31, 2, 'Coton de Tulear'),
(32, 2, 'Australian Cattle Dog'),
(33, 2, 'Dorky'),

(34, 2, 'Jack Russell Terrier'),
(35, 2, 'Retriever Mix'),
(36, 2, 'Pomapoo'),

(37, 2, 'Border Collie Mix'),
(38, 2, 'Maltese'),
(39, 2, 'Cocker Spaniel'),
(40, 1, 'Tabby'),

(41, 3, 'Goldfish'),
(42, 1, 'Manx'),
(43, 1, 'American Shorthair'),
(44, 2, 'Weimaraner'),

(45, 2, 'Australian Shepherd'),
(46, 2, 'Golden Retriver/Labrador Mix'),
(47, 2, 'Dachshund'),

(48, 2, 'Chocolate Lab'),
(49, 1, 'Siamese '),
(50, 2, 'Husky'),
(51, 1, 'Maine Coon'),

(52, 5, 'Bold Stripe Mack Snow'),
(53, 6, 'Vietnamese/Pot Belly'),
(54, 7, 'Provence'),
(55, 8, 'Barred Rock'),

(56, 8, 'Arucana'),
(57, 8, 'Buff Orpington'),
(58, 9, 'Domestic');



-- --------------------------------------------------------

--
-- Table structure for table `HW5_OWNER`
--


CREATE TABLE IF NOT EXISTS `HW5_OWNER` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `LastName` varchar(40) NOT NULL,
  `FirstName` varchar(40) NOT NULL,
  PRIMARY KEY (`ID`)
) 
ENGINE=InnoDB  DEFAULT CHARSET=latin1;



--
-- Dumping data for table `HW5_OWNER`
--



INSERT INTO `HW5_OWNER` (`FirstName`, `LastName`) VALUES
  ('Stanley','Clayton'),
  ('Makenna','Bray'),
  ('Kelsie','Maynard'),
  
('Kash','Silva'),
  ('Byron','Porter'),
  ('Valerie','Mitchell'),
  ('Jason','Bentley'),
  ('Haven','Ferguson'),
  ('Evan','Ray'),
  ('Emely','Berger'),
  
('Jensen','Barton'),
  ('Jayla','Good'),
  ('Dale','Horn'),
  ('Jaydin','Contreras'),
  ('Edward','Rhodes'),
  ('Oscar','Vang'),
  
('Casey','Colon'),
  ('Angela','Howe'),
  ('Magdalena','Mcintyre'),
  ('Beau','Camacho'),
  ('Darrell','Baker'),
  ('Rigoberto','Bush'),
  
('Braxton','Rowland'),
  ('Finnegan','Mercer'),
  ('Juliet','Haas'),
  ('Leonard','Wilkinson'),
  ('Destiny','Nicholson'),
  ('Adrianna','Miller'),
  
('Carissa','Oconnell'),
  ('Akira','Reynolds'),
  ('Darryl','Aguilar'),
  ('Gina','Watts'),
  ('Scarlet','Paul'),
  ('Kaia','Dixon'),
  ('Gordon','Page'),
  
('Isaac','Flowers'),
  ('Shawn','Chang');



-- --------------------------------------------------------

--
-- Table structure for table `HW5_PET`
--


CREATE TABLE IF NOT EXISTS `HW5_PET` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `Name` varchar(40) NOT NULL,
  `PetTypeIDfk` int(10) NOT NULL,
  `OwnerIDfk` int(10) NOT NULL,
  PRIMARY KEY (`ID`)
) 
ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=128 ;



--
-- Dumping data for table `HW5_PET`
--



INSERT INTO `HW5_PET` (`ID`, `Name`, `PetTypeIDfk`, `OwnerIDfk`) VALUES

(1, 'Rex', 1, 1),
(2, 'Pickles', 2, 2),
(3, 'Nemo', 3, 2),
(4, 'Copper', 4, 3),
(5, 'Parker', 5, 4),

(6, 'Perry', 6, 4),
(7, 'Madison', 7, 5),
(8, 'Milo', 8, 6),
(9, 'Otis', 5, 6),
(10, 'Charlie', 9, 7),

(11, 'Sophie', 10, 7),
(12, 'Cas', 11, 8),
(13, 'Bud', 12, 9),
(14, 'Gracie', 13, 10),
(15, 'Tucker', 14, 10),

(16, 'Molly', 12, 10),
(17, 'Yogi', 15, 10),
(18, 'Winnie', 16, 11),
(19, 'Mac', 17, 12),
(20, 'Coco', 18, 13),

(21, 'Ace', 19, 14),
(22, 'Ginger', 20, 15),
(23, 'Smoochie', 21, 15),
(24, 'Apollo', 22, 16),
(25, 'Sebastion', 12, 17),

(26, 'Huck', 23, 18),
(27, 'Tiger ', 24, 18),
(28, 'Velcro ', 25, 18),
(29, 'Patty', 26, 19),
(30, 'Zulu', 27, 20),

(31, 'Luna', 18, 20),
(32, 'Caesar', 28, 21),
(33, 'Shelby', 29, 22),
(34, 'Andrew', 30, 23),
(35, 'Max', 31, 24),

(36, 'Hachi', 32, 25),
(37, 'Ellie', 33, 25),
(38, 'Stuart', 34, 26),
(39, 'Bailey ', 35, 26),
(40, 'Oliver', 36, 27),

(41, 'Sophie', 37, 28),
(42, 'Snickers', 38, 29),
(43, 'Jolene', 25, 29),
(44, 'Lucky', 39, 30),
(45, 'Mushu', 40, 30),

(46, 'Sushi', 41, 31),
(47, 'Bo', 42, 32),
(48, 'Jerry ', 43, 32),
(49, 'Cam', 40, 32),
(50, 'Jet', 44, 32),
(51, 'Asher', 45, 33),

(52, 'Champ', 46, 34),
(53, 'Bo Rudy', 47, 34),
(54, 'Hershey Kiss', 48, 34),
(55, 'Zeek', 41, 35),
(56, 'Emory', 49, 35),

(57, 'Bentley', 50, 35),
(58, 'Big Krunchy', 51, 36),
(59, 'Princess Noah', 52, 36),
(60, 'Hank', 12, 37),

(61, 'Olive', 53, 37),
(62, 'Lima', 54, 37),
(63, 'Cocoa', 54, 37),
(64, 'Buster', 55, 37),
(65, 'Blackbeard', 56, 37),

(66, 'Honey', 57, 37),
(67, 'Ninja', 58, 37);



-- --------------------------------------------------------

--
-- Table structure for table `HW5_SPECIES`
--


CREATE TABLE IF NOT EXISTS `HW5_SPECIES` (
  `ID` int(10) NOT NULL AUTO_INCREMENT,
  `Species` varchar(35) NOT NULL,
  PRIMARY KEY (`ID`)
) 
ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;



--
-- Dumping data for table `HW5_SPECIES`
--



INSERT INTO `HW5_SPECIES` (`ID`, `Species`) VALUES
(1, 'Cat'),
(2, 'Dog'),
(3, 'Fish'),
(4, 'Rabbit'),
(5, 'Gecko'),
(6, 'Pig'),
(7, 'Donkey'),
(8, 'Chicken'),
(9, 'Duck');